Release 10.1A: OpenEdge Data Management:
SQL Reference

SYSCOLUMNS

Contains one row for each column of every table in the database.

Table 6 provides details of the SYSCOLUMNS table.

Table 6: SYSCOLUMNS core system table 

Column name	Column data type	Column size
charset	VARCHAR	32
col	VARCHAR	32
collation	VARCHAR	32
coltype	VARCHAR	10
dflt_value	VARCHAR	250
id	INTEGER	4
nullflag	VARCHAR	1
owner	VARCHAR	32
scale	INTEGER	4
tbl	VARCHAR	32
width	INTEGER	4